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 24347

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.

1473

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

2 5050

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

9 124361

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

3269





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

15 19183

what r the stages mostly used in realtime scenarios

4 19690

wt is the diff b/w odbc and oracle stage

2 14323

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 5178

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 4606

can a fact table contains textual information

6 7775

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

1 2284

why we use parameters instead of hard code in datastage

4 8679

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

9 18746

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 8924

Post New HCL Data Stage Interview Questions



Un-Answered Questions

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

792


HELLO EVERYONE ON YAHOO , I'M IN NIGERIA AND I Would LIKE TO MOVE AND WORK IN CANADA , ANY SKILLED WORK IS OK BY ME AND THE PERSON WILL PAY THE BILL FOR IT, I WILL SERVE THE PERSON FOR THE EXPENSES.......... LOVE TO READ FROM YOU SOONEST AS YOU WISH TO HELP ME OUT

1234


Can or have you customize the getContent Activity?

1


What are the main issues associated with multiprocessor caches and how might you solve them?

1054


Service tax applicable or not for Govt Guest House contract work.

955






how many maximum number of virtual users we can create?

938


What do you mean by controlling buyers workload?

7247


what is wavelenght and staylight? deferance beetween ultravoilet range and visible range.

891


Is the unit and normal value fuel ratio of an average diesel engine?

1237


At what places availability check performed? is it done at invoice level also ? if yes what are the scenarios to perform availability check at invoice level? what are the settings to be done to perform to check at invoice level?

443


Hi can you please send me recent(present) interview questions and technical qyestions with answers for "BUSSIESS OBJECTS" and "DATA WAREHOUSE".pls its urgent for me my mail id is sekhar.cs82@gmail.com,manjuforgis@gmail.com. thanks in advance

776


What ill be the shaft diameter with clearance having a bearing bore is 30mm?

1836


Write the test cases for checking a variable having value in range -10.0 to +10.0?

1028


HOW CAN YOU USE A PAGE COUNT IN CALLING A PAGE IN SMARTFORM?

907


Where to find the ISO accounting entry details?

995






HCL Data Stage Interview Questions
  • C (112)
  • STL (1)
  • OOPS (28)
  • C++ General (21)
  • MFC (19)
  • ATL (2)
  • COM DCOM (2)
  • Win32API (3)
  • VC++ AllOther (2)
  • Delphi (2)
  • PHP (25)
  • Programming Languages AllOther (23)
  • ASP (8)
  • CGI Perl (2)
  • JavaScript (6)
  • VB Script (3)
  • JSP (7)
  • Tcl (5)
  • jQuery (1)
  • Scripts AllOther (2)
  • SNMP (4)
  • TCP IP (18)
  • Protocols AllOther (7)
  • Networking Administration (56)
  • Networking Security (6)
  • Networking AllOther (17)
  • Visual Basic (10)
  • C Sharp (39)
  • ASP.NET (43)
  • VB.NET (4)
  • ADO.NET (8)
  • IIS (4)
  • Crystal Reports (2)
  • BizTalk (1)
  • Dot Net Framework (4)
  • Dot Net Remoting (2)
  • Dot Net WindowsForms (2)
  • Dot Net General (2)
  • Dot Net AllOther (5)
  • Exchange Server (9)
  • Microsoft Related AllOther (7)
  • Oracle General (16)
  • Architecture (3)
  • Database Management (11)
  • Forms Reports (4)
  • Oracle AllOther (9)
  • SQL Server (63)
  • MySQL (4)
  • Sybase (2)
  • SQL PLSQL (24)
  • Databases AllOther (2)
  • SDK (2)
  • Windows Threads (3)
  • Windows General (7)
  • Windows AllOther (11)
  • Linux Commands (16)
  • Linux Socket Programming (1)
  • Linux System Calls (2)
  • Linux General (4)
  • Linux AllOther (2)
  • Unix Commands (13)
  • Unix IPC (4)
  • Unix AllOther (5)
  • Solaris Commands (5)
  • Solaris System Calls (1)
  • Solaris General (4)
  • Solaris AllOther (14)
  • Operating Systems General Concepts (16)
  • Operating Systems AllOther (3)
  • WinRunner (4)
  • Load Runner (6)
  • QTP (39)
  • Test Director (3)
  • Rational TestSuite (2)
  • Silk Test (1)
  • Selenium (15)
  • Automation Testing AllOther (4)
  • Manual Testing (156)
  • QA Concepts (10)
  • Mobile Testing (3)
  • Test Cases (13)
  • Test Documents Reporting (1)
  • Testing AllOther (12)
  • Tomcat (1)
  • Apache (2)
  • Servers AllOther (1)
  • COBOL (28)
  • JCL (11)
  • CICS (5)
  • DB2 (7)
  • ADABAS (1)
  • Assembler (6)
  • MVS (2)
  • VSAM (4)
  • IBM MainFrame AllOther (2)
  • RPG400 (13)
  • COBOL400 (1)
  • DB400 (3)
  • IBM AS400 AllOther (9)
  • Core Java (65)
  • Advanced Java (26)
  • Swing (1)
  • EJB (9)
  • Servlets (13)
  • Struts (14)
  • JDBC (8)
  • J2EE (5)
  • Weblogic (26)
  • Java J2EE AllOther (13)
  • Java Related AllOther (10)
  • CORBA (1)
  • MQSeries (1)
  • XML XSLT RSS (3)
  • Teradata (3)
  • Business Objects (18)
  • Cognos (67)
  • Informatica (47)
  • Actuate (1)
  • Ab Initio (7)
  • Data Stage (26)
  • SAS (9)
  • ETL (4)
  • Data Warehouse General (6)
  • HR Questions (42)
  • UML (1)
  • OOAD (1)
  • Requirements Management (1)
  • Project Planning (6)
  • Project Management (1)
  • CTC (1)
  • Theoritical (1)
  • Visual Studio IDE (2)
  • Telecom Routers Switches (1)
  • VoIP IP Telephony (1)
  • GSM (1)
  • BlueTooth (1)
  • Telecom General (3)
  • Telecom AllOther (1)
  • SAP Basis (28)
  • SAP ABAP (67)
  • SAPScript (4)
  • SAP SD (39)
  • SAP MM (10)
  • SAP PP (4)
  • SAP FI CO (46)
  • SAP HR (7)
  • SAP CRM (2)
  • SAP SRM (1)
  • SAP Business Warehouse (9)
  • SAP Security (6)
  • SAP Netweaver (2)
  • SAP ALE IDocs (4)
  • SAP B1 (3)
  • PeopleSoft HRMS (2)
  • PeopleSoft Tools (1)
  • ERP General (1)
  • Oracle Apps Technical (7)
  • Oracle Apps Financial (32)
  • 86 Family (3)
  • VLSI (1)
  • Client Server General (1)
  • AI Neural Networks (1)
  • Digital Certificates (1)
  • Ciphers (2)
  • WebMethods (3)
  • TIBCO (2)
  • JCAPS (1)
  • Software Integration & Release (5)
  • Program Management (3)
  • Image Processing AllOther (2)
  • Pega (16)
  • Zoology (2)
  • Geo Physics (1)
  • Organic Chemistry (1)
  • General Science (5)
  • Sciences AllOther (1)
  • Civil Engineering (7)
  • Mechanical Engineering (17)
  • Electrical Engineering (90)
  • Electronics Communications (56)
  • Chemical Engineering (3)
  • Industrial Engineering (1)
  • Instrumentation (9)
  • Engineering AllOther (31)
  • Business Administration (1)
  • Marketing Sales (10)
  • Banking Finance (4)
  • Human Resources (9)
  • Industrial Management (1)
  • Infrastructure Management (1)
  • IT Management (1)
  • Non Technical (1)
  • Business Management AllOther (2)
  • Audit (2)
  • Taxation (10)
  • Accounting General (23)
  • Accounting AllOther (27)
  • Architecture Design AllOther (1)
  • Call Centre AllOther (204)
  • UPSC AllOther (1)
  • SSC History (1)
  • SSC General Studies (1)
  • SSC AllOther (3)
  • RRB (7)
  • CDS (1)
  • NDA (2)
  • POs (4)
  • BSRB Clerical (3)
  • Group I (2)
  • APPSC AllOther (5)
  • General Knowledge_Current Affairs (29)
  • Government AllOther (3)
  • Law AllOther (1)
  • Tourism Hotel AllOther (1)
  • Funny Interview Questions (3)
  • Everything Else AllOther (15)
  • English (19)
  • General Aptitude (88)
  • Puzzles (11)
  • Placement Papers (26)
  • CCNA (70)
  • CCDA (1)
  • Microsoft Certifications (6)
  • Sun Certifications (1)
  • CISA Certification (1)
  • Oracle Certifications (2)
  • ISTQB Certification (1)
  • Certifications AllOther (8)
  • H1B Visa (2)
  • USA Student Visa F1 Visa (1)
  • L1 Visa (9)
  • USA Business Visa B1 Visa (1)
  • USA Dependent Visa H4 Visa (3)
  • UK Visa (1)
  • Australia Visa (2)
  • Canada Visa (4)
  • C Code (49)
  • C++ Code (4)
  • J2SE Code (2)
  • ASP.NET Code (1)
  • VB.NET Code (1)
  • C Sharp Code (1)
  • ADO.NET Code (1)
  • PHP Code (1)
  • JavaScript Code (2)
  • WinRunner Code (1)
  • GATE (2)
  • OPENMAT (1)
  • ICET (3)
  • C C++ Errors (9)
  • Oracle Errors (5)
  • SQLServer Errors (1)
  • Scripts Errors (1)