Interested to Buy Any Domain ? << Click Here >> for more details...
I have a source as flat file and having data like
""TCS"MUMBAI" and i want output like TCS MUMBAI,the length
of the data in the rows is variable.how can you fix it?
- 5 Answers
- 13565 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / bob
Repacechr(1,""TCS"MUMBAI",'"',null)
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Under what condition selecting sorted input in aggregator may fail the session?
Plz can any one say me how to get the informatica certification materials and dumps
How many ways a relational source definition can be updated and what are they?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to extract the informatica rejected data?
What is data caches/ index caches?
How to do unit testing in informatica?
What is native users?
Explain the features of connected and unconnected lookup.
Can u generate reports in Informatica?
What is an unconnected transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Why update strategy and union transformations are active?
How do you load unique records into one target table and duplicate records into a different target table?
