Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

How can you join flat file, oracle as a sources?

Answers were Sorted based on User's Feedback

How can you join flat file, oracle as a sources?..

Answer / kalyanreddy

Hi Vijay,

first populate flatfile data to orale db

two methods,

1. write a join query in source oralce stage and link to

2. take two oracle sources like s1 and s2 , use join stage
and link to target

direct method

3.take flat file and oracle source, use join stage and link
to target.

Is This Answer Correct ?    5 Yes 1 No

How can you join flat file, oracle as a sources?..

Answer / vijay

First you convert the data from flat file into oracle , so
now we have two oracle db's then easily we can join these
two sources using join stage.

I have also faced this question at IBM US.

Is This Answer Correct ?    6 Yes 4 No

How can you join flat file, oracle as a sources?..

Answer / kiran

hai vijay..,

See Whats the Question and please first clear ur
questions.then give proper answer using flat files
also u can join and populated to target.please clear ur

Thanks & Regards

Is This Answer Correct ?    2 Yes 1 No

How can you join flat file, oracle as a sources?..

Answer / bharathd

By using Seqfile stage(flat file) and Oracle(Dynamic RDBMS
stage)to extract the data from sources, the join the data
using join stage.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

Thanks to all people who are posting their comments...

1 Answers   CTS,

What is the purpose of pivot stage?

0 Answers  

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 Answers  

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

1 Answers   IBM,

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 Answers   IBM,

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

2 Answers   TIAA CREF,

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,

what is repositery?

0 Answers   IBM,

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

how to write server Routine coding?

0 Answers   Eric,

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 ?

0 Answers   Wipro,