how to clear the source file?
2) diff b/t odbc & Oracle?what is node?
3) explain one complex job u face in ur project
Answers were Sorted based on User's Feedback
Answer / kiran
1)how to clear the source file?
Ana:by using 3rd Party tool u can clear the source
2) diff b/t odbc & Oracle?what is node?
Ans:Node: its used to split the data into its memory location
3) explain one complex job u face in ur project
Is This Answer Correct ? | 0 Yes | 8 No |
how to add a new records into source?
How to generate surrogate key without using surrogate key stage?
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
What is the difference between lookup and sparse lookup?
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
I have 100 records how can I load at a time from the single time
How did you reconcile source with target?
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?