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 19725i 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 8700how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
16 22144write 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 2911Can 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 9575split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 15006If 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 8978source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
7 11391Post New Cap Gemini Informatica Interview Questions
What is de-normalization in sql database administration? Give examples?
What is Testability ?
What are the different stages involved in database testing?
Why wind turbines wheels rotate constantly
1.What are the basic accounting Standards ?? 2.What is the main importance of Bank Reconcilation Statement? 3. What is Form 407 in Vat ??
distinguish between Bill of Exchange and Promissory Note
How do I lock an excel spreadsheet from editing?
What is the procedure you followed to upload the data?
What is the strong name in .net assembly?
Why vector class is used?
Explain all the file processing modes supported by python?
What is transparent table?
Can I disable windows defender?
What different services are provided by the IBM SmartCloud?
What is jquery a client or server scripting?