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 |
Whats there in global repository
What is the main difference between a Joiner Transformation and Union Transformation?
what is normalizer transformation?
what is diff between IN and EXIT commands
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
Issue with Update override at Target table in Informatica.
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
how to convert the .doc docs into .txt format using informatica
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
What is source qualifier transformation?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?