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 21157i 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 9684how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
16 24812write 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 15619If 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 9990source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
7 12365Post New Cap Gemini Informatica Interview Questions
What are System functions?
What is sae? Mention the importance of sae to the automobile domain.
How can you extend class in codeigniter?
What is lambda function in python?
Explain the use of inctype option in exp command.
What does the evm need to run a smart contract?
Define what is the metallurgical explanation of effects of chromium, nickel, molybdenum, and carbon in stainless steels?
How do you think you can make a contribution to Office Depot?
What is function in c with example?
What is global variable in javascript?
Explain union.
How do you change a file type in windows 10?
What is difference between stateless and stateful?
How do you read data from excel?
what is full assembly reference