Answer / kiran

any number of columns

Answer / kiransitams

any number of columns

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,

---

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

1 Answers   Cap Gemini,

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,

---

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

---

which memory is used by lookup and join

5 Answers   IBM,

---

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,

---

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,

---

To see hidden files in LINIX?

1 Answers   CTS,

---

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

---

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

4 Answers   IBM,

---

What are system variables and sequencers in datastage

1 Answers  

---