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 21208i 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 9728how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
16 24963write 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 3395Can 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 10476split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 15637If 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 10040source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
7 12427Post New Cap Gemini Informatica Interview Questions
Why fuzzy logic?
What percent of stars in the sky that appear to be single stars are actually binary stars?
what is repositery?
What are the Guidelines to be followed for SQL performance on ABAP on HANA?
Is oracle client required for jdbc connection?
What is port number in java?
How many major groups of cells are involved in acquired immunity?
What do you understand by Kurtosis() and Skew() functions?
What is css in coding?
Why is it called windows?
A process can run only in the background. State Whether True or False?
what are the features in cognos8ui
What is the difference between dhtml and html?
What is definition and declaration?
What is Prewitt gradient filters?