1)What 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 Answers
- 6259 Views
- Hexaware, I also Faced
- E-Mail Answers
What are the third party tools you used in your project?
How do you find the number of rows in a sequential file?
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
why we use hash file for lookup?
how many rows sorted in sort stage by default in server jobs
how does work server jobs?
What is mapping?
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
What are the differences between datastage and informatica?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
Teradata 
