Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 25818

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.


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

2 5829

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

9 130756



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

15 21332

what r the stages mostly used in realtime scenarios

4 20657

wt is the diff b/w odbc and oracle stage

2 15659

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 5746

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 5084

can a fact table contains textual information

6 8927

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

1 2740

why we use parameters instead of hard code in datastage

4 9463

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

9 20537

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 9851

Post New HCL Data Stage Interview Questions

HCL Data Stage Interview Questions

Un-Answered Questions

Apache Spark is a good fit for which type of machine learning techniques?


How to Send an image to the printer ?


as a fresher what is the format for resume and suggest me some career objectives too........


How to elaborate powercenter integration service?


Explain how you can run rails application without creating databases?


What are the benefits of using windows services:


Hi Friends Rajendra this is bhavani prasad, iam working Hyderabad. i faced one problem with qtp recording mode i.e in my application there is 100 records first we click the first record that record will be jumped to next session and 99 records will there stop the recording and run the same script .Run this script qtp does not identify the records. So plz tell me what is the solution.


How does hbase actually delete a row?


Explain the significance of “dead beef”?


advantage of motor design on higher power factor . normally motors are designed for .8 power factor. what is advantage of designing at .88 power factor


What is the command enable-debug?


What is sitemesh?


Don't be too quick to dump your plugin or applet based portions of your application. While ajax and dhtml can do drag and drop and other advanced user interfaces there still limitations especially when it comes to browser support. Plugins and applets have been around for a while and have been able to make ajax like requests for years. Applets provide a great set of ui components and apis that provide developers literally anything.


What internally happens when bw objects like info object, info cube or ods are created and activated?


Is pl sql different from sql?