Results 1 to 4 of 4

Thread: flat 2 flat file load

  1. #1
    Junior Member
    Join Date
    Oct 2012
    Posts
    12

    Question flat 2 flat file load

    hi all
    if only sorce name and path is given then how to load the actual data into target

    sorce target
    path id name add
    d:\***********\s1.txt 10 AA add1
    d:\***********\s1.txt 20 AA add2
    d:\***********\s1.txt 30 AA add3

    my s1 contain 10 AA add1
    s2 contain 20 AA add2
    s3 contain 30 AA add3


    here many people suggest me do indirect file type for loading
    but my problm is i cant alter my source definition which is already imported and contain only one column called
    PATH
    one person also suggest me 2 doing through unstructured data transformation.
    any suggestion is appreciable

    if any one have used unstructured data transformation plz also gave some guideline to configure unstructured data transformation. also

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    512
    It is easier to modify the source structure instead of using the unstructured transformation.

    I dont know how to use unstructured data transformation. From what I heard is, you have to do lot of manipulation to get the desired structure if you use unstructured data transformation.

  3. #3
    Junior Member
    Join Date
    Oct 2012
    Posts
    12
    ok thx vijay

    but my limitation is i cant altered my source defination

  4. #4
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    512
    connect SQ to expression transformation and in the expression transformation, split the source data into multiple columns.

Similar Threads

  1. Flat file loading scenario in informatica
    By Nandan in forum Data Warehouse
    Replies: 2
    Last Post: 10-17-2013, 06:24 AM
  2. Load first N rows from a flat file - Informatica
    By vijay in forum Data Warehouse
    Replies: 0
    Last Post: 07-26-2012, 10:12 AM
  3. Replies: 2
    Last Post: 07-18-2012, 08:37 AM
  4. Replies: 1
    Last Post: 07-12-2012, 12:09 PM
  5. Replies: 3
    Last Post: 05-28-2012, 04:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •