Answer Posted / jvdwhinfo
Using Seq. generator we can delete the desired record from
flat file.
Please let me know if you have any suggestions.
Thanks,
James
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
What is meant by lookup transformation?
draw informatica architecture 8.6 ?
expain about the tune parameters?
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
How can we use mapping variables in informatica? Where do we use them?
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.
Performance tuning( what you did in performance tuning)
difference between repository database and repository service?
what is INFORMATICA TESTING process
What is option by which we can run all the sessions in a batch simultaneously?
What is parallel processing in informatica?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
how many types of dimensions are available in informatica?
What are mapplets? How is it different from a Reusable Transformation?