Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Data Stage Interview Questions
Questions Answers Views Company eMail

How to lode data in sequntional files perform faster?

Polaris,

1 2500

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

Polaris,

2 5121

What is diff between Junk dimensions and conform dimension?

Polaris,

4 9091

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 3972

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

3604

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

Satyam,

2 10514

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 1322

Please tell me What is difference between 8.0 and 8.1

IBM,

1 4742

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

Cap Gemini,

1 7422

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

Virtusa,

2 7773

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 6774

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

TCS,

5 16561

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

IBM,

4 7926

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

1 2489

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 6790


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

What are the functionalities of link partitioner and link collector?

147


What is the difference between datastage and datastage tx?

151


What are operators in datastage?

158


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

1221


Why fact table is in normal form?

180






How can you write parallel routines in datastage PX?

158


Differentiate between datastage and informatica?

150


How do you import and export the datastage jobs?

170


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1167


What are the types of containers and how to create them?

147


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

2892


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

1974


What are routines in datastage?

155


Lookup constraints

383


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2239