WAT IS TEXT LOAD?
Answers were Sorted based on User's Feedback
Answer / pradeep
I think it's not text load, rather it is TEST LOAD
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / kotesh
First it is not text load, it is test load
the power center reads, transforms data and without writing
into targets. the power center generates all session files
and pre-post sql functions, as if running full session. the
power center writes data into relational targets. but
rollbacks data when the session is completes.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / somu
i think
if you want to text the records from one table
that time you can go to session properties and select text
load option and give number like how many rows you want to
test(ex: 10)
after completion of the session you cant able to see the
tested records in your target table
you would get o/p like: no rows should be selected
| Is This Answer Correct ? | 0 Yes | 0 No |
Can we insert ,update ,delete in target tables with one update strategy tran.?
What is the difference between view and materialised view?
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
how to get flatfile containg 10 records half records one target another half another target
how can we perform incremental aggregation?explain with example?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
What is the query to find nth highest salary? What is the use of cursors?
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
Enlist the tasks for which source qualifier transformation is used.
How we will implement Pushdown Optimization and Types in Informatica with better examples