Answer / rams

dsx file datastage code back up file the code will be imported to another syatem we can use this format

Answer / bharathram1234

.dsx file is nothing but the datastage project backup file..
when we want to load the project at the another system or server we take the file and load at the other system/server...

Answer / guru v

.dsx file means Datastage job only.when you take the back up of the job that time its saved in .dsx format.

Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 Answers  

---

WHAT IS FORCE COMPILE?

3 Answers   FIS, HCL, Polaris,

---

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---

Where do the datastage jobs get stored?

0 Answers  

---

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 Answers   TCS,

---

---

A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?

1 Answers   TCS,

---

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,

---

how will u design file watch jobs?

2 Answers  

---

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,

---

Differentiate between operational datastage (ods) and data warehouse?

0 Answers  

---

what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,

---

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

3 Answers   Cap Gemini,

---