Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
3 7373i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
3 6599Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
5 13239following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
8 12843How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
5 10250If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
2 7841If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
2059My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
3 7107I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
2 7642Post New TCS Informatica Interview Questions
What is relation between mu(nought) and epsilon(nought)?
How do I connect to an sql server instance that is running on a machine with multiple instances of sql server 2000? : BEA Weblogic
Tell me what type of scenarios can be automated?
How can we create new transaction codes in sap?
Explain the developer trace?
What is an ongoing maintenance?
why we use copper earthing for neutral while for body GI.
Is it better, to kill the black alkali in the soil with gypsum, just to scatter it over an alkalied spot or to plow the soil first and then use the gypsum if you are going to sow alfalfa?
Why is declarative transaction management preferred in spring?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How many types of inheritance are there in c#?
What are the three ods objects table explain?
Can we print bar codes in SAP only from ZEBRA printer ?
What challenges do AI-powered education systems face?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?