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
- 13445 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / chanakya123
Dear Chow,thanks for ur reply, the SQ reading "" only from
""TCS"MUMBAI",the rest of the part truncated,then how can u
use ltrim and rtrim, i tried it creating a mapping.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which development components of informatica have the highest usage?
What is a stored procedure transformation?
update strategy transformation in informatica
define galaxy repository in informatica
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is the Rank index port in Rank transformation?
Explain the types of lookup transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is meant by LDAP users?
how to load rows into fact table in data warehouse
In which transformation you cannot drag ports into it?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are the different types of olap? Give an example?
