Answer / datastage4you

Some Interview Questions and Scenario -

http://www.datagenx.net/p/datastage-scenario.html
http://www.datagenx.net/p/datastage-posts.html
http://datastage4you.blogspot.in/p/blog-page_15.html

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,

---

What is the difference between an operational datastage and a data warehouse?

0 Answers  

---

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

---

Sequential 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?

1 Answers   TCS,

---

where we use config file as parameter ?

1 Answers   IBM,

---

State the difference between an operational datastage and a data warehouse?

0 Answers  

---

Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 Answers  

---

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

---

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

1 Answers   Reliance,

---

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

---

How to use Environment variable's in datastage?(use of process)

1 Answers   CSC,

---

HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,

---