Define oconv () and iconv () functions in datastage?

0 Answers  

---

How do you get log info into a file?

1 Answers  

---

If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers  

---

What could be a data source system?

0 Answers  

---

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

---

How one source columns or rows to be loaded in to two different tables?

0 Answers  

---

what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

1 Answers   TCS,

---

How to Remove Duplicate using SQL?

0 Answers   CTS,

---

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,

---

Is it possible to query a hash file?

0 Answers   IBM,

---

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  

---

how to find no.of records in sequntial file itself?

4 Answers  

---