how can we validate the flat files using the date in the
header and number of records in the flat file? Using both
conditions at a time.
No Answer is Posted For this Question
Be the First to Post Answer
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Define Data Stage?
What are operators in datastage?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Why do we use exception activity in Datastage?
Define data aggregation?
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.