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 does the session recovery work.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
Briefly explain the aggregator transformation?
what is parameter file?
which one is better performance wise joiner or look up
explain about informatica server architecture?
What are the circumstances that infromatica server results an unreciverable session?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
How to load data in informatica ?