1. How to remove '#' from the output
In the session target property
a. select Header Option as Use header command output , and
b. in the Header Command use echo command to write the field names as
echo field1, field2, field3
2. What are the issues you have faced while working with the flat files in informatica?
1. If we want to apply sorting at source qualifier, we can't do.
2. Some times we get source with ',' (comma) in the string itself, but the the file is comma delimited. because of that session failed.
3.There is a big chances of junk characters in the flat file which are not require in the target.
4. We have to be very careful while giving the file path.
In the session target property
a. select Header Option as Use header command output , and
b. in the Header Command use echo command to write the field names as
echo field1, field2, field3
2. What are the issues you have faced while working with the flat files in informatica?
1. If we want to apply sorting at source qualifier, we can't do.
2. Some times we get source with ',' (comma) in the string itself, but the the file is comma delimited. because of that session failed.
3.There is a big chances of junk characters in the flat file which are not require in the target.
4. We have to be very careful while giving the file path.
No comments:
Post a Comment