1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
5 Data Stage 12914if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
5 Data Stage 13411how to transfer file from one system to another system in unix? which cmd to be use?
5 Data Stage 13570A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?
TCS,
3 Data Stage 8666SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?
TCS,
1 Data Stage 5787What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
1 Data Stage 5386Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
TCS,
4 Data Stage 8850how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
HCL,
Data Stage 1713Two source files contains same meta data third file contains different data types can I funnel that file.
2 Data Stage 6803