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 |
How to Create a folder using pmrep command?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
what are challenges that you faced in testing? give solution to it?
How You Pull the records on daily basis into your ETL Server.
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
why we are using level option in normalizer transformation
Is it possible to update the target table with PK?
What are the reusable transformations?
WHat all joins are there in Source Qualifier?
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
How the informatica server increases the session performance through partitioning the source?