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 18941i 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 8271how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
16 20993write 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 2663Can 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 9247split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 14691If 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 8525source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
7 10909Post New Cap Gemini Informatica Interview Questions
What are styles?
What is attribute casting and how does it work in eloquent?
why does the array will be start on size 0?
Is it possible to build our modules in ansible?
How to perform a sap-export and import tables in sap from os level?
Mention what are the differences between amazon s3 and ec2?
how to export outlook folders to another format?
Which transport directory is used to implement support package and add-ons?
What are tomcat threads?
How do I copy data from multiple worksheets into one?
What is db2 optimizer?
What is repository info. Systems?
What is motor sequence learning?
Is double bigger than float?
What are validator? Name the validation controls in asp.net? How do you disable them?