Can you create a flatfile target
Answers were Sorted based on User's Feedback
Answer / nikita jain
yes, In Target design tab of Designer there are options like import from flatfiles also create table there we can select the type as flat file.
we can add the column names after creating the flatfile target instance.
Is This Answer Correct ? | 0 Yes | 0 No |
how can we use sorter transformation in joins?
Explain scd type 3 through mapping.
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
What is the difference between OLTP and ODS?
What are the diffrences between joiner transformation and source qualifier transformation?
what is the size of your data warehousing?
How do you handle decimal places while importing a flatfile into informatica?
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
hi real timers . iam waiting for ur reply regarding ETL TESTING