Answer / vijay

don't more explanation...just it is ALIGNING SOUCE COLUMNS
TO TARGET COLUMNS WITH OR WIHOUT USING STAGE.

Answer / maruthi

MAPPING.)IN INFORMATICA MAPPING IS REFERRED AS A COLLECTION
TRANSFORMATION AND CONNECTING THEM.
IN DATAS TAGE WE WILL CALL THE SAME MAPPING AS JOB
JOB IS A COLLECTION OF STATGS LINKED TOGETHER.

Answer / ramjanaki

I think you are referring to the Mapping of Columns in the
Transformer Stage.

It is nothing but relating the columns from the source
stage to the target in the Transformer stage by drag and
drop. Transformations like for example, doing some
condition check, applying some functions etc., can be done
here and the resultant data will be loaded to the target.

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers   CTS,

---

Explain the situation where you have applied SCD in your project?

0 Answers  

---

What is datastage engine?

0 Answers  

---

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

---

What are the types of views in datastage director?

0 Answers  

---

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

0 Answers   UHG,

---

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,

---

1.what is materialized data? 2.how to view the materialized data?

0 Answers   HCL, IBM,

---

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?

0 Answers   IBM,

---

Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,

---

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers  

---

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers  

---