I learned two things -
1. Don't blindly believe when people say it can't be done.
2. Informatica lets you create SQL statement to create target table.
I've been working to load this massive VSAM file with more than 1500 fields. Creating the source definition from the COBOL copybook was simple but creating ORACLE table manually for these many fields dampened my spirits.
I asked one of the more senior guys around here if he knew how to do it since he has been working on the same project with me. He said it wasn't possible and that I needed to do it manually.
I came back crushed and started reading Informatica Manual to delay my nemesis (so dramatic but seriously 1500 fields!).
It's then I learned that once the target definition has been created, Target Designer lets you "Generate/Execute SQL" for the target. BINGO! I was done in 2 minutes.
PS - To create target definition, I just dragged and dropped the source definition to target designer.
1. Don't blindly believe when people say it can't be done.
2. Informatica lets you create SQL statement to create target table.
I've been working to load this massive VSAM file with more than 1500 fields. Creating the source definition from the COBOL copybook was simple but creating ORACLE table manually for these many fields dampened my spirits.
I asked one of the more senior guys around here if he knew how to do it since he has been working on the same project with me. He said it wasn't possible and that I needed to do it manually.
I came back crushed and started reading Informatica Manual to delay my nemesis (so dramatic but seriously 1500 fields!).
It's then I learned that once the target definition has been created, Target Designer lets you "Generate/Execute SQL" for the target. BINGO! I was done in 2 minutes.
PS - To create target definition, I just dragged and dropped the source definition to target designer.
No comments:
Post a Comment