Interested to Buy Any Domain ? << Click Here >> for more details...
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
- 4 Answers
- 7323 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raghav
i feel that the format of tha file specified with in
informatica is wrong. What i mean in, say the format of the
file is UNICODE and that specifed in informatica is ASCII or
vise versa such problems may occur.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gyana
Use a expression and use the REPLACE() fUNCTION TO REPLACE
ALL THE ? TO SPACE..BUT I DON'T UNDERSTAND Y IT READ LIKE
THAT..PLEASE CLARIFY ME IF U WILL GET ME
(gyana.informatica@gmail.com)
| Is This Answer Correct ? | 1 Yes | 0 No |
Use a expression and use the REPLACECHR ( ) fUNCTION TO REPLACE
ALL THE ? TO SPACE..Then only you will get the out put as Ravi Teja.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gyana
Use a expression and use the REPLACE() fUNCTION TO REPLACE
ALL THE ? TO SPACE..BUT I DON'T UNDERSTAND Y IT READ LIKE
THAT..PLEASE CLARIFY ME IF U WILL GET ME
(gyana.informatica@gmail.com)
| Is This Answer Correct ? | 0 Yes | 1 No |
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
What is batch and describe about types of batches?
in what type of scenario bulk loading and normal loading we use?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
In ur current projectu have done any performance tuning of mappings?
What is transformation?
how can we calculate fact table size?
Where are the source flat files kept before running the session?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
Teradata 
