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 24591

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.

1495

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

2 5179

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

9 125553

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

3317





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

15 19544

what r the stages mostly used in realtime scenarios

4 19859

wt is the diff b/w odbc and oracle stage

2 14556

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 5269

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 4686

can a fact table contains textual information

6 7971

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

1 2351

why we use parameters instead of hard code in datastage

4 8804

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

9 19068

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 9085

Post New HCL Data Stage Interview Questions




HCL Data Stage Interview Questions





Un-Answered Questions

Slip joints are provided in the propeller shaft a) To adjust the inclination of the propeller shaft b) To adjust the length of the propeller shaft c) To prevent the whirling of the propeller shaft d) To adjust the up and down movement of the rear axle

296


What is the difference between cfm (cubic feet per minute) and scfm (standard cubic feet per minute)?

5


The structure of keyword driven frame work is like a folder structure the different sub folder are 1-functional libray folder 2-object repository folder 3- database folder 4-appliction1.xls 5-initalzation vbs file 6-sequence file 7-driver script 8-test case list file My question is whether these are in a local server machine or in our pc.((whether It like Vss). can u give example of driver script(code)

2166


If 24 KVA AVR having Input voltage 200-400v, Output voltage 415+-1%, what will be the voltage if Load is 13A.

998


What is Mointer in Operating System?

537






What is the full form of stomp?

1


what is pulse logic system?

7


i opt cse branch in engineering.which subject i have choose in civil service preliminary examination

917


HI GUYS,, I HAVE 3 YEARS OF EXP IN MANUAL TESTING...NEXT MONTH ONWARDS I WORK FOR MOBILE TESTING....PLS SUGGEST ME WHAT I LEARN FOR TRAING,, MOBILE TESTING OR ANDROID....FOR MOBILE TESTERS NEED ANDROID(IFONE) DEVOLOPMENT KNOWLEDGE OR NOT? EXPLAIN CLEARLY

986


What is the difference between indian and us payroll. (I said each of them have their own its and the taxation differs.)

21


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

1166


When does an atoll start to form?

4


What happens to existing data in my cluster when I add new nodes?

8


What are the different input sources for Spark Streaming?

3


Write a program to explain the comparator?

1