Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.02 seconds.

  1. Answers
    15
    Views
    30,028

    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
    22,300

    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
    1,646

    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
    1,859

    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
    22,300

    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
    2,389

    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
    3,098

    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
    3,721

    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
    2,322

    Data Warehousing - Re: Loading for 6th Record

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

    Please follow the step given by cme_prak
  10. Answers
    2
    Views
    6,328

    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
    3,392

    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
    2,001

    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
    1,403

    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
    4,674

    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
    1,704

    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
    1,687

    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
    1,454

    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
    1,841

    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
    1,964

    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
    11,836

    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
    1,500

    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
    3,172

    Congrats - Member(s) of the Month

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

    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
    7,427

    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