Answer / erwa

Preparing the Extracted Data to be loaded to the DWH.
Preparing like examine each extracted file, review the
Business rules, perform the various data transformation
functions, resolve inconsistencies, Sort & Merge data, etc.

Answer / saikiran katari

staging area is a temporary storage area.which is loaded with all the transaction data and while loading in to staging area we are not suppose to perform single transaction activity..
if i am telling is wrong..send me current answer my mail..
mail id: katari079@gmail.com

Answer / chandan.g

STAGING AREA is nothing but a temporary memory (resting area ) of the data which is converted initially from the source we get and can be converted into the desired format

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

0 Answers  

---

I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

3 Answers   IBM,

---

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

---

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,

---

What is difference between server jobs & parallel jobs?

0 Answers  

---

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

---

What is staging variable?

0 Answers  

---

What is ibm datastage?

0 Answers  

---

HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?

1 Answers   Infosys,

---

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

---

How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,

---

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want

3 Answers  

---