i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
9 21419i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
5 9890how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
16 25402write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
1 3471Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 10608split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 15717If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
4 10170source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
7 12637Post New Cap Gemini Informatica Interview Questions
Explain what is Robo-electric testing framework?
What is the difference between polymorphism and abstraction?
What does kernel panic mean?
Explain how to initialize a const data member.
What is aws and how does it work?
Which command is used to uncompress gzip files?
example of SOP
Why do we use pragma autonomous transaction?
What are the main areas in aviation?
What is $_ request?
Explain the difference between "my" and "local" variable scope declarations. ?
What is the difference between entity framework and mvc?
Is there an equivalent of c's "?:" Ternary operator?
How do you create a formula?
Traverse the given tree using Inorder, Preorder and Postorder traversals. Inorder : D H B E A F C I G J Preorder: A B D H E C F G I J Postorder: H D E B F I J G C A