The below are the hackerrank test questions
1.If a flat file has 100 million records and need to load the distinct records by eliminating the duplicates to the target table.
2.if a Workflow 1 runs then workflow 2 should trigger and then workflow 3 without using scheduling tool.
3.Workflow 1 should run and fail then after 1minute of time the same workflow should trigger the same should repeat to workflow 2 and workflow 3. explain the process.
4.we have n records in a file and it should load the data as n-2 records in target(need to filter the records)
5.Source table contains duplicate rows.the data has to load all the unique rows in 1 target while all the duplicate rows in another target.expalin the process?
6.what are mapping parameters and variables in informatica? explain with example
7.Explain about the SCD types and their implementation process?
8.What are the limitations in mapplet?
9.Difference between HTTP transformation and WSC(Web Service Consumer) Transformation.
10.What is top down approach and Bottom Up Approach and which one do you prefer?
11.What is the difference between copy and shorcut?
12.Difference between Joiner and lookup?
13.How to update a target record without using update strategy transformation?
14.Can you implement SCD type 2 in Source Qualifier transfomation and how?
15.Explain bottlenecks in informatica with an example?
16.Explain Static,Dynamic and Persistent caches?
17.Explain session partitioning in informatica with examples?
18.one multiple choice question
total 20 questions they will ask
