Search:

Type: Posts; User: sanghala; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.00 seconds.

  1. Answers
    15
    Views
    36,050

    Data Warehousing - Re: Typical Informatica Scenarios

    Hey Kripa,

    Source is a faltfile and want to load unique and duplicate records separately into two separate targets; right ??

    Here comes the solution -
    SRC - SQ_SRC - SRT - EXP - RTR - TGT
    ...
  2. Answers
    12
    Views
    25,890

    Data Warehousing - Re: Session Error in Informatica

    Just try to recover it as it failed at initialization and please keep the error message clearly :confused:
  3. Answers
    2
    Views
    3,854

    Data Warehousing - Re: Can any 1 help me.........

    Prakash, :)

    Nice info provided for the requestee...@!

    And a nice quotation from you thru sign...
  4. Thread: Informatica

    by sanghala
    Answers
    2
    Views
    4,197

    Data Warehousing - Re: Informatica

    If you wannah to prepare the list, you can get thru Repository Manager or else only wrt to session just follow with what prakash told....!

    Thru rep manager - you can get all the info. Check out...
  5. Answers
    12
    Views
    25,890

    Data Warehousing - Re: Session Error in Informatica

    Vague error message -
    Can you try to keep it completely...! Not all the log - only the error code. :confused:
  6. Answers
    5
    Views
    4,708

    Data Warehousing - Re: Looking for a job in Informatica

    Getting trained will not help an inch.

    Keep on coding with different case studies. It may help to survive.
    And donot mention where exactly you are trained. It sounds bad though that place makes...
  7. Answers
    1
    Views
    5,228

    Data Warehousing - Re: Mapplets in informatica........

    Mapplet is created in a Mapplet designer where as a reusable transformation is created in Transformation developer or Mapping designer.

    The unsupported repository objects in Mapplet are –



    ...
  8. Answers
    3
    Views
    6,002

    Data Warehousing - Re: Informatica related

    Friend Som,

    Can you reply back whether you mean to say either one of these ?


    DEADLOCK on database level
    Write Lock on Informatica level

    Both will be caused because of the unautorized...
  9. Answers
    5
    Views
    4,396

    Data Warehousing - Re: Loading for 6th Record

    With what Chiru........! :mad:

    Please follow the step given by cme_prak
  10. Answers
    2
    Views
    8,528

    Data Warehousing - Re: Difference between Database and Repository

    Have you aware of what exactly mean by Database and Repository...!

    Your question is something like what the difference between eggs & Apples ??
    Sorry if my answer hurts and Please relate the...
  11. Answers
    4
    Views
    5,320

    Data Warehousing - Re: Lookup Transformation

    sanghala - Back in action

    Friend,

    What prakash jotted odwn was very nice and good explanation.

    Adding to that -
    It is the most imporatnt and powerful transforamtion thru which you can...
  12. Thread: Hi guys

    by sanghala
    Answers
    3
    Views
    4,165

    Data Warehousing - Re: Hi guys

    @Uday,

    Is the same possible in Oracle 9.2 Version..!
    ________________________________________________________
    And in addition to the above, we can use conditional statements also.
  13. Thread: Lookup Query?

    by sanghala
    Answers
    1
    Views
    3,043

    Data Warehousing - Re: Lookup Query?

    Hey Srinu,

    Can you please be more descriptive on the above question...?

    More thoughts on this ....! So touch this again...
  14. Answers
    3
    Views
    6,917

    Data Warehousing - Re: Cognos 7, ReportNet 1.1 and Cognos 8

    Friends,

    Now Cognos8 BI version 8x vastly used by many companies..!
    So, if any one is having comparison chart of benefits of cognos 8 over cognos 7.3.

    Thanks in Advance...
  15. Answers
    1
    Views
    3,437

    Data Warehousing - Re: COPYING from Shared folder

    If all the users are having write access on Non-Shared folder (As per your saying), then its no way called as Non-Shared Folder...

    But I Suggest you to go for the First Option,
    i.e., Source -...
  16. Data Warehousing - Re: How to send bad records on the fly to a file

    Dear Murali,

    As per above info, you are having mainframe source loading into a relational table.

    Can you implement Expression(which creates flag for duplicate records), then Router (to route...
  17. Answers
    1
    Views
    3,309

    Data Warehousing - Re: SQL connection error while running workflow

    Hi Sandeep,

    Check out with MS-SQL DBA...

    But beofre doing so, try to fix this by resuming the job. Hope this will do the needful...

    If your job failing again... then contact your DBA...
  18. Answers
    1
    Views
    3,195

    Data Warehousing - Re: Connected & unconnected

    As per transformations -

    Connected mean which is present in the data flow.

    Unconnected mean which is totally isolated from the data flow.


    Hope you asked about the transformations...
  19. Thread: dwh

    by sanghala
    Answers
    4
    Views
    3,896

    Poll: Data Warehousing - Definitons of DW Terms

    @vasu,
    ods - operation data store is the database where the recent information is stored. In ods (based on the company requirement), they will store the data for recent days/months/years.

    dss -...
  20. Answers
    4
    Views
    3,976

    Data Warehousing - Re: Skip sequence in job

    @Amar,

    It is very simple. Just disable the Second session which you donot wannnah to run. As you run the workflow, after successful completion of second session, the execution passes to the third...
  21. Answers
    4
    Views
    14,049

    Data Warehousing - Re: Real time questions in Banking Project

    @debasisdas,

    May I know, From this link - you have searched for "complex+mapping+in+informatica" in Google.

    Hope this will give the list of complex mappings referal urls - what abt the banking...
  22. Answers
    2
    Views
    3,314

    Data Warehousing - Re: Datatype for Updated_time

    I hope this will not solve the problem if he needs the 5 digits after seconds..

    What you say debasisdas?

    Ramesh - Let me know these 5 digits are important to have ?
  23. Answers
    13
    Views
    5,515

    Congrats - Member(s) of the Month

    My hearty congratulations.... :) to all...!
  24. Answers
    1
    Views
    3,047

    Data Warehousing - Re: Load N no of files in target in one session

    @Ramesh -

    Firstly, you asked abt the source - it will be the directory of flat-files and target - where you want to load these data ( for Eg - xyz_table).

    Then mapping is similar to flatfile...
  25. Answers
    1
    Views
    9,629

    Data Warehousing - Re: Scheduling tools in Informatica

    In Real time, The jobs are sheduled as the following -


    Informatica sheduler.
    Cron jobs.
    Opcon jobs.


    Hope there are other third party tools by which the batches can be scheduled.
Results 1 to 25 of 99
Page 1 of 4 1 2 3 4
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact