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 19201i 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 8432how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
16 21491write 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 2762Can 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 9385split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 14844If 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 8694source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
7 11100Post New Cap Gemini Informatica Interview Questions
how to set kernal parameters in solaris 10&9?
the difference between part number and serial number
What are teradata utilities?
How do I change the default font in microsoft word 2010?
How is object methods defined in ruby?
What is document parking and why is it important when consideration internal control procedures and “segregation of duties”?
What relationship is between a process, application domain, and application?
What does the “abstract” keyword mean in front of a method? A class?
C language questions for civil engineering
What is @inject in spring?
Differentiate between
What are the ways in which weblogic servers can run on multiple machines?
What language is c# similar to?
Does Low-level recording capture mouse movements?
What is number function in sql?