1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

Gallega, TCS,

how to sort records in sql?

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

Cap Gemini,

how to create document in datastage?

Cap Gemini,

how to transfer file from one system to another system in unix? which cmd to be use?

Cap Gemini,

when u face critical situation in ur project, how to solve them?

Toyota,

how to cleansing data

Cap Gemini,

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?

TCS,

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

TCS,

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?

Hexaware,

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

TCS,

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

HCL,

hw will u use awk in replacing cahrs and files

1)Source file contains one record, I want 100 records in target file.

Two source files contains same meta data third file contains different data types can I funnel that file.