Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

HCL Data Stage Interview Questions
Questions Answers Views Company eMail

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 32769

create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

 2871

How to create environments and call them? What is the use defined variables?

 2 9260

what is the main differences between Lookup, Join and Merge stages?

 9 149625

HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

 1 8546

Hi This is Vijay, How can your remove the duplicates in sequential File?

 15 31946

what r the stages mostly used in realtime scenarios

4 25481

wt is the diff b/w odbc and oracle stage

 2 20547

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 8720

1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

 1 7587

can a fact table contains textual information

 6 14688

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

 1 5030

why we use parameters instead of hard code in datastage

 4 13765

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

 9 29294

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?

4 14067

Post New HCL Data Stage Interview Questions


HCL Data Stage Interview Questions


Un-Answered Questions

can any one send me the real time interview questions and tockets in sap fico ,my mailid is c.sujatha2008@gmail.com

2033

What if I write static public void instead of public static void?

963

sir, give me placement papers and interview quistion of birla group company of copper.

2955

can anybody mail the exact sylabuss for ECIL

2218

How to Change a users password from unix shell.

1250

What will happened if the neutral of the (star connected secondry) Xformer disconnected? (if its Above KVA rated one)

2267

What do you know about the recent satellite launch?

1203

what is inventory valuation pls Explain in detail?

430

I NEED 2006&2007 RAILWAY RECRUITMENT BOARD,JUNIOR ENGINEER (SIGNAL) Q&ANSWERS,PLEASE SEND TO: kaleelbe@yahoo.com

1971

Can you declare an array without assigning the size of an array?

1243

Which accounting applications are your familiar with?

1096

What is the difference between equals() and == in java?

1067

Write a java program to find the route that connects between Red and Green Cells. General Rules for traversal 1. You can traverse from one cell to another vertically, horizontally or diagonally. 2. You cannot traverse through Black cells. 3. There should be only one Red and Green cell and at least one of each should be present. Otherwise the array is invalid. 4. You cannot revisit a cell that you have already traversed. 5. The maze need not be in the same as given in the above example

2704

What is java string pool?

1110

What is your work experience in pharmaceutical field?

1224