| Other Data Stage Interview Questions |
|| Asked @
|can we see the data in fixed width file? how can u change
the datatype of fixed width files?
|1.which index is follows the dimensions tables?why?
2.what is the use of trigger in job sequence?
3.what is the mean of optimization?
4.what is the job control?when we use it?
what is difference bet batch and sequencer?
6.seq--->seq,seq--->copy--->seq which one is best and efficient?
|| ||1 |
|in one scenario source flat file like
divide each 5 numbers as one column i.e
here i need
field1 field2 field3 field4
00122 00155 00562 00568
00256 00236 00145 00896
00123 00456 00789 00258
00147 00456 00258 00256
plz help me....
|| ||3 |
|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
|| ||1 |
please design job for this,
MY INPUT IS
MY OUTPUT IS
I am getting data from sequential file like below
But I need the target column as like below
A and B
C and D
A and E
X and Y and Z
v and x
|| ||7 |
|A flatfile contains 200 records.I want to load first 50
records at first time running the job,second 50 records at
second time running and so on,how u can develop the job?pls
give the steps?pls pls
|source which format u will get either fixed or delimiter
length format? what is the symbol of delimiter?
Can u pls tell me
How can u Call the Shell Scripting/Unix Commands in Job
|how can we do null handling in sequential files
|if we using two sources having same meta data and how to
check the data in two sources
is same or not? and if the data is not same i want to abort
the job ?how we can do this?
|how can we create a Sorrogate key in transformer stage? I
want it in parallel mode
|For more Data Stage Interview Questions Click Here |