Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Data Stage Interview Questions
Questions Answers Views Company eMail

What is RCP

CGI, CTS,

5 21811

How can we achive parallelism

CTS,

1 7860

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

TCS,

4 10629

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,

2188

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

3 9326

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

2 8164

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 6109

I have 100 records how can I load at a time from the single time

1 5283

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

2 6741

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 8897

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.

4047

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

Cap Gemini,

11 21278

source file contains 100 records, i want 10 records in target file how it possible in datastage

IBM,

6 24471

one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

IBM,

8 13287

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

TCS,

1 4169


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Can you explain link buffering?

1185


What are the different layers in the information server architecture?

1129


How many areas for files does datastage have?

1156


What are some different alternative commands associated with "dsjob"?

1169


How a routine is called in datastage job?

1122


how to add a new records into source?

2001


What are the steps required to kill the job in Datastage?

1218


What are stage variables and constants?

1152


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2244


What is difference between server jobs & parallel jobs?

1042


what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1088


Explain datastage architecture?

1405


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

1234


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2483


How to Remove Duplicate using SQL?

1373