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 |
what is curr val use for in sequence generator?
How to recover sessions in concurrent batches?
What are the types of schemas we have in data warehouse and what are the difference between them?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
Reusable transformation and shortcut differences
can we have to do changes in session property when we are dynamically generating target files?
Explain the aggregator transformation?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
Write the different tools in the workflow manager?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.