What if the source is a flat-file?
No Answer is Posted For this Question
Be the First to Post Answer
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the difference between Bulk Load and Normal Load
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
What is a joiner transformation and why it is an active one?
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
How to generate sequence numbers without using the sequence generator transformation?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
what is degenerated dimension?
can a port in expression transf be given the name DISTINCT