Answer / phani kumar

Sequential file doesn't handle nulls. If the file contains
nulls, then it gives records while reading the file by using
sequential stage,only records which are not having nulls.

In order to handle nulls, there is a option available in
seq.file as NULL TO VALUE. Here, we can give any value for
replacing of Nulls.

Then, DS Engine will consider those symbols are nulls while
reading the data from sequential file.

Thanks and regards,
Phani kumar

Answer / kak

In sequential file we have one property null to value or
null to zero using that we can handle the nulls.

Answer / hari

YA UR EXACTLY RIGHT PHANI.

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

0 Answers  

---

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,

---

How will you move hashed file from one location to another location?

0 Answers   NTT Data,

---

when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,

---

What is the purpose of pivot stage and types of containers in datastage

0 Answers  

---

i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

5 Answers   TCS,

---

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

1 Answers   IBM,

---

What is container and then types?

1 Answers  

---

what is flow of project?

0 Answers   HSBC, IBM,

---

detail about sdlc

4 Answers  

---

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

---