Data Stage Interview Questions
Questions Answers Views Company eMail

Difference between data warehousing and olap?

819

What is the difference between operational data stage (ods) and data warehouse?

943

What are the types of containers in datastage?

909

Explain entity, attribute and relationship in datastage?

837

Difference between in process and inter process?

901

What are stage variables and constants?

890

What are the components of datastage?

844

What are the differences between datastage and informatica?

824

Explain the importance of surrogate key in data warehousing?

916

How to implement complex jobs in data stage?

845

Difference between server jobs & parallel jobs?

835

Difference between ‘validated ok’ and ‘compiled’ in data stage?

883

What are the functionalities of link collector?

821

What is the purpose of pivot stage?

828

What are the various kinds of the hash file?

875


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

how to delete one row in target dataset

2817


Define orabulk and bcp stages?

885


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

536


In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

786


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3026


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2241


Why fact table is in normal form?

875


what are the errors,warnings in datastage

2381


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

575


What is the difference between odbc and drs stage?

822


Which commands are used to import and export the datastage jobs?

1154


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

1938


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2148


What all are the different way to run a job?

816


What is the purpose of pivot stage?

828