Data Stage Interview Questions
Questions Answers Views Company eMail

How to lode data in sequntional files perform faster?

Polaris,

1 3450

I have a few records just I want to store each records tow times in target how?

Polaris,

2 6287

What is diff between Junk dimensions and conform dimension?

Polaris,

4 11000

i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?

2 5349

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4550

what is difference between migration project and integration project? can anyone explain with the example Thanks in advance

Satyam,

2 11745

Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 2130

Please tell me What is difference between 8.0 and 8.1

IBM,

1 5531

i have flat file and using unix how can i generate sequence number into targer?

Cap Gemini,

1 8914

plz tell me some dimentional and fact table names in banking project?

Virtusa,

2 9090

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

Cap Gemini,

3 8594

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

TCS,

5 20360

source file is having 5 records while moving into target it want to be 10 records

IBM,

4 9689

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 3305

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

TCS,

7 9201


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How you can fix the truncated data error in datastage?

1184


Have you used Unstructured data?

824


Differentiate between odbc and drs stage?

583


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

974


How to RD using transformer?

850






What can we do with datastage director?

663


how to abort the job its matain duplicates?

2091


Is it possible to query a hash file?

1552


How do you register plug-ins?

592


Differentiate between operational datastage (ods) and data warehouse?

664


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

2834


What are the functionalities of link collector?

618


Whats difference betweeen operational data stage (ods) and data warehouse?

656


What is the difference between informatica and datastage?

647


What is the use of datastage designer?

628