there is a comma separated flat file as source and there is
a column in that one field is having space like "rama
krishna" like that what happens when this is used as source
Answers were Sorted based on User's Feedback
Answer / srinivas
i have tested when we use coma seperated file it should
take only rama krishna as single column
Is This Answer Correct ? | 23 Yes | 0 No |
Answer / kishore
Hi,
I think ...it will take separate column when comma(,) occurs
only..... "rama krishna: as single column only....
Is This Answer Correct ? | 11 Yes | 1 No |
What is the function of union transformation?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
Does Facttable Normalized or Denormalized?
What is joiner cache?
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
Explain lookup transformation is active in informatica
What are the Differences between static cache and dynamic cache?
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
Explain pushdown optimization $pushdownconfig parameter - informatica
why we use stored procedure transformation?
what is worklet and what use of worklet and in which situation we can use it?