how can we extract data with out having any common column
Answer Posted / siri
Hi,
If meta data is same u can achieve this in 2 ways.
1) In job properties -> before job subroutine -> cp file1.txt file2.txt
2) Use Funnel
Meta data is not same then you need key.(With out key it is not possible)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is aggtorec restructure operator?
why do u need the IOS upgradation in a FC switch
How do you schedule or monitoring the job?
State the difference between an operational datastage and a data warehouse?
how to abort the job its matain duplicates?
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
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
EXPLAIN SCD
How to RD using transformer?
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.
Difference between data warehousing and olap?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are some different alternative commands associated with "dsjob"?