explain any diffcult scenario that u have faced in your
experience... or explain any complex maping u have
developed?
No Answer is Posted For this Question
Be the First to Post Answer
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
Do you find any difficulty while working with flat files as source and target?
Why use shortcuts(Instead of making copies).
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
can we have to do changes in session property when we are dynamically generating target files?
tell me the push down optimization
What is the Router transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records