What is the default execution order of the sequential file?
Answer Posted / shar
It behaves different w r t reading capability.
i.e.,
when it is reading a single file; it does sequential mode of
reading by default and when it is reading multiple files it
does parallel mode of reading by default.
And if we need to improve performance of sequential file
stage when reading a single large file then we have two
options:
1. Read from Multiple Nodes
2. No of readers per node.
1st one is applicable only when flat file is Fixed length
file and not applicable for delimited formatted files.
The latter one is applicable for delimited files by
mentioning no of nodes then it performs parallel mode of
execution by reading single file in partitions improving the
performance.
Thats it.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
which r the connectors used in san?
Why do you need stage variables?
Can you explain repository tables in datastage?
Which algorithm you used for your hashfile?
Which commands are used to import and export the datastage jobs?
Can you filter data in hashed file?
How the ipc stage work?
Does datastage support slowly changing dimensions ?
What is the difference between Datastage 7.5 and 7.0?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Can we use target hash file as a lookup ?
Define meta stage?
Have you used Unstructured data?
What is staging variable?