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

Define data aggregation?

0 Answers  

---

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,

---

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---

What is the difference between datastage and informatica?

0 Answers  

---

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,

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  

---

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,

---

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

---

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,

---

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,

---

What are stage variables?

0 Answers  

---

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,

---