Answer / vaibhav

I think, here the question is... if F1 & F2 both are 'N' then the records with same I_D should be dropped.. correct Prasad?

if this is the case we need to find ans for this scenario..

Answer / bharath

Hi friend..
question may not clear..
my question is..
in what based on I_D s 100,103,105 don't want to send to
target?

Out of my knowledge
1.change the Field names as new field names by using modify stage as follows
Give at specification as
'ID = I_D; flag1=F1; flag2;'
2.Give the field delimiter=tab
and final delimiter=end

then u get

clear my question?
thank you..

Answer / akila

Looks like if both the flags for any ID are 'N' then all
the records of that particular ID are not sent to output.

For this, first sort the data using ID, F1, F2(all in asc
order).

Next in a transformer stage variables,
svOldID = svNewID
svNewID = ID
svCompare = If svOldID=svNewID then 'N' else 'Y'
svRejectedID= If svCompare='Y' and F1='N' and F2='N' then
ID else svRejectedID

In the output link contraint: ID<>svRejectedID

Answer / bharath

Hi,
please find the below answer.

|------seq1
src---->trans-----
|------seq2


in transformer stage give constraint as follows

src.f1="N" And src.f2="N"

check other wise link on seq2link.

then you get..

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

---

How did you reconcile source with target?

2 Answers   HP,

---

where we use config file as parameter ?

1 Answers   IBM,

---

how to define satge variables in transformer stage

2 Answers  

---

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,

---

What is difference between join, merge and lookup stage?

0 Answers  

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers  

---

why we use hash file for lookup?

5 Answers  

---

I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 Answers  

---

hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer 

1 Answers   HCL,

---

How can we do null handling in sequential files?

3 Answers   Reliance,

---

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers  

---