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 |
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
If a table contains 100 records we have to fetch 50-100 records from source to target?how
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
Define update strategy?
how to declare array in plsql?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
Different types of Power center errors?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
expain about the tune parameters?