Howmany ways yoU can update a relational source defintion
and what are they?
Answer / swetha
Two ways
1. Edit the definition
2. Reimport the defintion
| Is This Answer Correct ? | 2 Yes | 0 No |
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
why we use stored procedure transformation?
what is the method of error handling when session is running?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
what is the command to get the list of files in a directory in unix?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
explain abt joiner t/r?
How to display First letter of Names in Caps?
What does reusable transformation mean?
Which transformation is needed while using the Cobol sources as source definitions?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?