1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category
Data Stage Interview Questions
Questions Answers Views Company eMail

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

Satyam,

2 7690

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

 2 6309

Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.

 2 5023

how to design the change capture stage in(data stage parallel jobs) type 2

IBM,

2 48154

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

TCS,

2 8562

where we use column generator stage in real time scenario?

TCS,

5 24492

How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.

 5 20938

when we will use connected Lookup & Unconnected Lookup

Wipro,

3 9826

which cache supports connected & un connected Lookup

Wipro,

1 4957

can we use sequential file as a lookup

Cognizant, Wipro,

7 21209

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

Wipro,

1 6486

what is Audit table?Have u use audit table in ur project?

Accenture, Wipro,

3 21910

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

Wipro,

2 7913

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

Wipro,

2 7466

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

TCS,

2002

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the types of views in datastage director?

1234

How to Remove Duplicate using SQL?

830

Differentiate between data file and descriptor file?

610

What is difference between server jobs & parallel jobs?

615

What is the use of hoursfromtime() function in transformer stage in datastage?

576




I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

541

Lookup constraints

831

What is the roundrobin collector?

632

What is the difference between passive stage and active stage?

809

Define APT_CONFIG in Datastage?

655

Demonstrate experience in maintaining quality process standards?

1916

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2415

How complex jobs are implemented in datstage to improve performance?

584

How do y read Sequential file from job control?

14376

Have you have ever worked in unix environment and why it is useful in datastage?

637

For More Un-Answered { Data Stage } Questions Click Here