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.

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

1 Answers   ABC, TCS,

---

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?

1 Answers   IBM,

---

What are the different kinds of views available in a datastage director?

1 Answers  

---

Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?

7 Answers   IBM,

---

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,

---

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,

---

Difference between data warehousing and olap?

1 Answers  

---

what is ds administrator used for?

1 Answers  

---

what is a force compile

2 Answers   Cap Gemini, IBM,

---

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 Answers  

---

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

---

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,

---