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 21156i 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 9683how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
16 24811write 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 3378Can 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 10445split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 15618If 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 9989source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
7 12363Post New Cap Gemini Informatica Interview Questions
What is Rack awareness?
What is the syntax used in Perl grep function?
State Maximum Power Transfer theorem.
What are the no-load losses for the 11000/415V transformer with the following rated capacity? 1.1500 kVA 2. 2000 kVA 3. 2500 kVA 4. 3000 kVA
What request type from a rest resource allows one update the contents of a file?
What is use of final keyword in java?
What is the use of view model in asp.net mvc?
What are the modulation techniques used in bluetooth technology?
what are the methods to measure managerial effectiveness
what are the sales document types in sap? What is the configuration step to define sales document type in sap sd?
Have you ever challenged, shaken old work methods.
What does finger do in linux?
What is the role of tables in database?
Do we need hadoop for spark?
How to add foot-node & end note in word?